<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:jfn="http://org.demo.xslt.Funtions"
    exclude-result-prefixes="jfn">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/mysql">
<db2>
    <xsl:for-each select="customer">
    <xsl:variable name="ip" select="'localhost'"/>    
    <client id="{key}">
        <uuid><xsl:value-of select="jfn:uuid()"/></uuid>
        <name><xsl:value-of select="concat(firstName,lastName)"/></name>
        <note><xsl:value-of select="comment"/></note>
        <host><xsl:value-of select="$ip"/></host>
        <createTime><xsl:value-of select="jfn:dateTime()"/></createTime>
        <source><xsl:copy-of select="."/></source>
    </client>
    </xsl:for-each>
</db2>
</xsl:template>
</xsl:stylesheet>